package com.nothing.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.nothing.base.BaseDao;
import com.nothing.domain.UserFaceInfo;
/**
 * 
 * @author shíQíang㊚
 *
 */

public interface UserFaceInfoDao extends BaseDao<UserFaceInfo>{
	@Select("<script>"
			+"SELECT id,name,face_id as faceId,face_feature as faceFeature,group_id as groupId FROM USER_FACE_INFO WHERE GROUP_ID = #{groupId} and checked = 0"
			+"</script>")
    List<UserFaceInfo> findByGroupId(Long groupId);
	@Select("<script>"
			+"SELECT id, name,age,gender,face_id as faceId,IMG_PATH as imgPath,group_id as groupId FROM USER_FACE_INFO WHERE FACE_ID = #{faceId}"
			+"</script>")
    UserFaceInfo findByFaceId(String faceId);
}
